Skip to main content

01-03 Excel-Object-Model-Cheat-Sheet

Excel Object Model Cheat Sheet​

This cheat sheet will provide a quick glance at the most commonly used objects in Excel and how they are related. It is meant to be a useful check when you know what you want to work with but are not certain how best to get there.

TODO: finish this list

  • Application

  • Workbooks -> Workbook

    • Worksheets -> Worksheet
    • Range -> Range
      • Formula
      • Value
      • Address
      • [formatting things]
      • Cells / Rows / Columns
    • Cells -> Range
    • ChartObjects -> ChartObject
      • Chart
        • Series
        • Axes -> Axis
        • ChartArea
        • PlotArea
    • Shapes -> Shape
    • Names -> Name
    • RefersToRange -> Range